package org.wpahs.ahn.rssfeed.DB;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * !!!!!!!!!!!!!!!!!!!!!NOT BEING USED!!!!!!!!!!!!!!!!!
 * Created by dgambone on 01/19/2015.
 */
public class DBStatistics extends FeedsDB{


    public DBStatistics(Context context) {
        super(context);
    }

    public abstract class DB {

        public static final String TABLE_NAME = "Service";
        public static final String COLUMN_ITEM_ID = "itemid";
        public static final String COLUMN_FEED_ID = "feedid";
        public static final String COLUMN_TITLE = "title";
        public static final String COLUMN_DESCRIPTION = "description";
        public static final String COLUMN_URL = "url";
        public static final String COLUMN_PUB_DATE = "publishedDate";
        public static final String COLUMN_IMAGE = "image";
        public static final String COLUMN_READ = "read";

        public static final String SQL_CREATE_TABLE =
                "CREATE TABLE " + TABLE_NAME + " (" +
                        COLUMN_ITEM_ID + " INTEGER PRIMARY KEY autoincrement," +
                        COLUMN_FEED_ID + " INTEGER," +
                        COLUMN_TITLE + " TEXT_TYPE, " +
                        COLUMN_DESCRIPTION + " TEXT_TYPE, " +
                        COLUMN_URL + " TEXT_TYPE, " +
                        COLUMN_PUB_DATE + " TEXT_TYPE, " +
                        COLUMN_IMAGE + " TEXT_TYPE, " +
                        COLUMN_READ + " INTEGER, " +
                        "FOREIGN KEY (" + COLUMN_FEED_ID + ") REFERENCES " + DBMyFeed.DB.TABLE_NAME + "(" + DBMyFeed.DB.COLUMN_FEED_ID + ")" +
                        ");";

    }
}
